// 教师相关的SQL语句
module.exports = {
  // 获取教师信息
  GET_TEACHER_PROFILE: `
    SELECT t.*, u.username, u.real_name, u.phone, u.email 
    FROM teacher_profiles t
    JOIN users u ON t.user_id = u.id
    WHERE t.user_id = ?
  `,

  // 创建教师信息
  CREATE_TEACHER_PROFILE: `
    INSERT INTO teacher_profiles (
      user_id, specialties, experience_years, 
      certification, introduction, achievement
    ) VALUES (?, ?, ?, ?, ?, ?)
  `,

  // 更新教师信息
  UPDATE_TEACHER_PROFILE: `
    UPDATE teacher_profiles 
    SET specialties = ?, experience_years = ?, 
        certification = ?, introduction = ?, 
        achievement = ?
    WHERE user_id = ?
  `
}; 